The Database API > Database API functions > MMDB.getColumnAndTypeList()

 

MMDB.getColumnAndTypeList()

Availability

Dreamweaver UltraDev 1.0

Description

Gets a list of columns and their types from an executed SQL SELECT statement.

Arguments

connName, statement

connName is the UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source.
statement is the SQL SELECT statement to execute.

Returns

An array of strings representing a list of columns (and their types) that match the SELECT statement, or an error if the SQL statement was invalid or the connection could not be made.

Example

The code var columnArray = MMDB.getColumnAndTypeList("EmpDB","Select * from Employees") returns the following array of strings:

columnArray[0] = "EmpName" , columnArray[1] = "varchar", ¬
columnArray[2] = "EmpFirstName", columnArray[3] = "varchar", ¬
columnArray[4] = "Age", columnArray[5] = "integer"